REPEAT UNTIL LOOP

Course- Oracle/PLSQL >

This Oracle tutorial explains how to use the REPEAT UNTIL LOOP in Oracle with syntax and examples.

Description

Oracle doesn't have a REPEAT UNTIL LOOP, but you can emulate one with a LOOP statement.

Syntax

The syntax for emulating a REPEAT UNTIL LOOP in Oracle/PLSQL is:

LOOP

   {...statements...}

   EXIT [ WHEN boolean_condition ];

END LOOP;

Parameters or Arguments

statements
The statements of code to execute each pass through the loop.
boolean_condition
Optional. It is the condition to terminate the loop.

Note

  • You would use an emulated REPEAT UNTIL LOOP when you do not know how many times you want the loop body to execute.
  • The REPEAT UNTIL LOOP would terminate when a certain condition was met.

Example

Let's look at an example of how to emulate a REPEAT UNTIL LOOP in Oracle/PLSQL:

LOOP
   monthly_value := daily_value * 31;
   EXIT WHEN monthly_value > 4000;
END LOOP;

In this example, we want the loop to repeat until monthly_value is greater than 4000, so we use the EXIT WHEN statement.

EXIT WHEN monthly_value > 4000;

Now, the LOOP would repeat until the monthly_value exceeded 4000.